The following error might occur when you attempt to open Microsoft Excel when inserted into another Microsoft Office application such as Microsoft Word:

This error will most likely occur when you have another Microsoft Excel session open at the same time that you are attempting to open the Microsoft Excel data embedded in the Microsoft Office application. Even if you have the configuration option LoadWhenEmbedded set to false, the error still occurs because Microsoft Excel is already open and the initial check will not rerun to see if the SAS^® Add-In for Microsoft Office should load or not.

To circumvent this problem with the SAS Add-In 2.1 or 4.2, use one of the following methods:

• Make sure the first occurrence of Microsoft Excel is closed before you attempt to open the embedded Microsoft Excel. This circumvention works only when the LoadWhenEmbedded configuration option is set to false in the SAS.OfficeAddin.dll.config file, as shown below:

<add key="LoadWhenEmbedded" value="false"/>

• Add the following configuration option to the SAS.OfficeAddin.dll.config file:

<add key="ForceGarbageCollection" value="true"/>

Note: If the SAS.OfficeAddin.dll.config file does not exist in the SAS Add-In for Microsoft Office installation directory, then you can create it and add the following lines with the key configuration options:

<configuration>
      <assemblySettings>
          <add key="LoadWhenEmbedded" value="false"/>
          <add key="ForceGarbageCollection" value="true"/>
      </assemblySettings>
</configuration>

With the SAS Add-In 4.3, you must disable the SAS Add-In in your first Microsoft Excel session before you can open the other Microsoft Office application.

Operating System and Release Information